How to get the sum for every distinct value in another column?

Question

Aryan Kumar · Answer

Sure, you can get the sum for every distinct value in another column using the
GROUP BY clause and the SUM() function. The syntax is as follows:
SQL
SELECT distinct_column_name, SUM(column_name)
FROM table_name
GROUP BY distinct_column_name;
For example, if you have a table called products with the columns
name and price, you could use the following SQL statement to get the sum of all product prices for each unique product name:
SQL
SELECT name, SUM(price)
FROM products
GROUP BY name;
This would return a table with two columns: name and sum. The
name column would contain the unique product names, and the sum column would contain the sum of all product prices for each unique product name.
Here is an example of how to get the sum for every distinct value in another column in MySQL:
SQL
CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);
INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300),
('Product 1', 400),
('Product 2', 500);
SELECT name, SUM(price)
FROM products
GROUP BY name;
This will return the following result:
name | sum
------+-----
Product 1 | 500
Product 2 | 700
Product 3 | 300
As you can see, the GROUP BY clause has grouped the rows in the 
products table by the name column. The SUM() function has then been used to calculate the sum of all product prices for each unique product name.

forum

How to get the sum for every distinct value in another column?

Revati S Misra

Can you answer this question?

1 Answers

Liked By